create table if not exists d_enp_ppm_ismg_htwg_business_h_#{PARTITION_DATE}
 (
ismpj01           datetime          ,  
ismpj02           datetime          ,
ismpj03           varchar(128)      ,
ismpj04           varchar(64)       ,
ismpj05           varchar(64)       ,
ismpj06           varchar(64)       ,
ismpj07           varchar(64)       ,
ismpj08           varchar(64)       ,
ismpj09           bigint            ,
ismpj10           bigint            ,
ismpj11           double            ,
ismpj12           bigint            ,
ismpj13           bigint            ,
ismpj14           double            ,
ismpj15           bigint            ,
ismpj16           bigint            ,
ismpj17           bigint            ,
ismpj18           bigint            ,
ismpj19           double            ,
ismpj20           bigint            ,
ismpj21           bigint            ,
ismpj22           double            ,
ismpj23           bigint            ,
ismpj24           bigint            ,
ismpj25           double            ,
ismpj26           double            ,
ismpj27           bigint            ,
ismpj28           bigint            ,
ismpj29           bigint            ,
ismpj30           bigint            ,
ismpj31           double            ,
ismpj32           varchar(10)       

)   compress(5, 5)  nolock ;